from openpyxl import load_workbook
workbook=load_workbook(filename='D:\\sms\\python02\\工作.xlsx')
sheet=workbook.active
data=[
    ['a',1],
    ['b',2],
    ['c',3],
    ['d',4],
]
for row in data:
    sheet.append(row)
workbook.save(filename='D:\\sms\\python02\\工作.xlsx')